CREATE TABLE [dbo].[ComponentRegistry]
(
[ComponentKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_ComponentRegistry_ComponentKey] DEFAULT (newid()),
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ComponentRegistry_Name] DEFAULT (''),
[Description] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ComponentRegistry_Description] DEFAULT (''),
[InterfaceName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ComponentRegistry_InterfaceName] DEFAULT (''),
[TypeName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ComponentRegistry_TypeName] DEFAULT (''),
[AssemblyName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ComponentRegistry_AssemblyName] DEFAULT (''),
[ConfigureWebUserControl] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ComponentRegistry_ConfigureWebUserControl] DEFAULT (''),
[ConfigureWindowsControl] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ComponentRegistry_ConfigureWindowsControl] DEFAULT (''),
[IsTyped] [bit] NOT NULL CONSTRAINT [DF_ComponentRegistry_IsTyped] DEFAULT ((0)),
[IsBusinessItem] [bit] NOT NULL CONSTRAINT [DF_ComponentRegistry_IsBusinessItem] DEFAULT ((0)),
[ComponentSummaryContentKey] [uniqueidentifier] NULL,
[ComponentNewLink] [nvarchar] (768) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComponentEditLink] [nvarchar] (768) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComponentExecuteLink] [nvarchar] (768) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeploymentPackageCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ComponentRegistry] ADD CONSTRAINT [PK_ComponentRegistry] PRIMARY KEY CLUSTERED ([ComponentKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ComponentRegistry_Name_InterfaceName] ON [dbo].[ComponentRegistry] ([Name], [InterfaceName]) ON [PRIMARY]
GO